﻿IF EXISTS (SELECT * from sys.procedures p left join sys.schemas s on p.schema_id = s.schema_id where p.name='search_delete' and s.name='Meta')
DROP PROCEDURE [Meta].search_delete
GO
CREATE PROCEDURE [Meta].search_delete 
@PK uniqueidentifier
AS
BEGIN
DELETE FROM 
	[Meta].[Search]
WHERE
	[Search].[id_reference] = @PK 
END